<?php
session_start();
include("lp_source.php");

$connection = @mysql_connect($db_host, $db_username, $db_password);
$db_select = @mysql_select_db($db_database);

$query = "SELECT name, gender, race, totalKills FROM characters ORDER BY totalKills DESC LIMIT 20";
$i='1';
$topkills = @mysql_query($query);
echo "<table align='center' width='750'>
<tr><td>
<tr>
<tr>
<td valign='top'><font size='3' color='6600FF'>Number</font></td>
<td valign='top'><font size='3' color='6600FF'>Name</font></td>
<td valign='top'><font size='3' color='6600FF'>Top Kills</font></td>
</br>

</tr>

</tr>";?>
<?php
while($pvp_row = mysql_fetch_assoc(($topkills)))
{
  
  echo '<tr><td><p>-='. $i .'=-</p></td><td><p>'. $pvp_row["name"] .'</p></td><td><p>'. $pvp_row["totalKills"] .'</p></td></tr>';
  $i++;
}
echo "</table><br>";

echo '</table>';
?>